﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Maticsoft.DBUtility;

namespace ElingOA6_Admin_DSJCJ.DAL
{
    public partial class ItemPurchaseApplyEntry
    {

        /// <summary>
        /// 获取明细数据
        /// </summary>
        /// <creator>chenly</creator>
        /// <date>2013-9-29</date>
        /// <param name="paperID">订单编号</param>
        /// <returns>数据列表</returns>
        public DataSet GetListEntry(decimal itemPurchaseApplyID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select FItemPurchaseApplyEntryID,FItemPurchaseApplyID,FItemName,FItemSpec,FQty,FPrice,FAmount,FRequestDate,FNote ");
            strSql.Append(" FROM dbo.t_ItemPurchaseApplyEntry ");
            strSql.Append(" where FItemPurchaseApplyID=@FItemPurchaseApplyID");
            SqlParameter[] parameters = {
					new SqlParameter("@FItemPurchaseApplyID",SqlDbType.Decimal)};
            parameters[0].Value = itemPurchaseApplyID;

            return DbHelperSQL.Query(strSql.ToString(), parameters);
        }


    }
}
